package com.jh.paymentchannel.repository;

import com.jh.paymentchannel.pojo.HZQuickBank;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

@Repository
public interface HZQuickBankRepository  extends JpaRepository<HZQuickBank,String>,JpaSpecificationExecutor<HZQuickBank>{

	/**
	 * 通过银行名称查询银行代码
	 * @param bankName
	 * @return
	 */
	@Query("select hzquickbank.bankCode from  HZQuickBank hzquickbank where hzquickbank.bankName like %:bankName%")
	public String getHZQuickBankCodeByBankName(@Param("bankName") String bankName);
	
}
